FaStudentLPPaymentPeriod 
Logical Entity Name  FaStudentLPPaymentPeriod 
Default Table Name  FaStudentLPPaymentPeriod 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

FaStudentLPPaymentPeriod Columns 
ColumnName  Domain  Datatype  NULL  Definition 
FAStudentLPPaymentPeriodID(PK)    int  NO 
 
Sequence    int  NO 
 
StartDate    datetime  NO 
 
EndDate    datetime  NO 
 
Credits    numeric(9, 2)  YES 
 
Weeks    numeric(9, 2)  YES 
 
FAStudentLoanPeriodID(FK)    int  NO 
 
FAStudentAidID(FK)    int  YES 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
ExcludefromAutoAdjust    bit  NO 
 
IWMilestone    datetime  YES 
 
UnitsMilestone    datetime  YES 
 
Completed    bit  YES 
 
AOSTransferComplete    bit  NO 
 
FullWeeksInPP    money  YES 
 
BBAYIWMilestone    datetime  YES 
 
ScheduledComplete    bit  NO 
 
NotEligibleForT4    bit  NO 
 

FaStudentLPPaymentPeriod Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_FaStudentLPPaymentPeriod_FaStudentLPPaymentPeriodID  PrimaryKey  FAStudentLPPaymentPeriodID 

FaStudentLPPaymentPeriod Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
FaStudentAid  Non-Identifying  Zero or One to Zero or More  FK_FaStudentLPPaymentPeriod_FAStudentAid_FAStudentAidID      FAStudentAidID  NO  YES 
FaStudentLoanPeriod  Non-Identifying  One To Zero or More  FK_FaStudentLPPaymentPeriod_FaStudentLoanPeriodID_FaStudentLoanPeriod_FaStudentLoanPeriodID      FAStudentLoanPeriodID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_FaStudentLPPaymentPeriod_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
SaReturnOfT4  Non-Identifying  One To Zero or More  FK_SaReturnofT4_fastudentlpPaymentPeriodId_fastudentlpPaymentPeriod_fastudentlpPaymentPeriodId        NO  YES 

FaStudentLPPaymentPeriod Check Constraints 
Check Constraint Name  CheckConstraint 

FaStudentLPPaymentPeriod Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

FaStudentLPPaymentPeriod Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentAcademicYearLoanPaymentPeriod 
NO       
Physical (Microsoft SQL Server)
dbo.FaStudentLPPaymentPeriod 
NO       

FaStudentLPPaymentPeriod Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  RefundCalculation 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Financial Aid 

FaStudentLPPaymentPeriod Data Movement Rules 
Name  Type  Rule Text/Value